﻿DECLARE
    @fragmentName varchar(255)

SET @fragmentName = 'GenericWebMetaDataIsManySegmentsToManyDocuments'

IF NOT EXISTS(SELECT * FROM Fragment WHERE FragmentName = @fragmentName)
BEGIN
    INSERT INTO Fragment (FragmentName) VALUES (@fragmentName)
END

UPDATE
    Fragment
SET
    ItemChar = 'no'
WHERE
    FragmentName = @fragmentName